a541d5f9f18afb5530b275e36b2e8fc161f219a3,tests/frontend/org/voltdb/planner/TestIndexSelection.java,TestIndexSelection,testSkipNullPartialIndex,#,484
Before Change
// skipNull is required - index predicate is not NULL-rejecting for column B
AbstractPlanNode pn = compile("select count(*) from c where b > 0 and d > 0;");
checkIndexName(pn, PlanNodeType.INDEXCOUNT, "\"TARGET_INDEX_NAME\":\"PARTIAL_IDX_3\"");
checkIndexSkipNullPredicateIsNull(pn, false);
}
{
// CREATE INDEX partial_idx_3 ON c (b) where d > 0;
After Change
// skipNull predicate is redundant and eliminated
AbstractPlanNode pn = compile("select count(*) from c where g < 0;");
checkIndexName(pn, PlanNodeType.INDEXCOUNT, "\"TARGET_INDEX_NAME\":\"PARTIAL_IDX_6\"");
checkIndexSkipNullPredicateIsNull(pn, false);
}
{
//CREATE INDEX partial_idx_6 ON c (g) where g < 0;